SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[spSuaNhaHang](@maDoanhThu int,@tongTienBan int,@tongTienNhap int,@chiPhiKhac int,@luongNV int ,@doanhthu int,@ngayTongKet datetime,@maNH int)
As
Begin
	Update DoanhThu
		Set
			TongTienBan = @tongTienBan,
			TongTienNhap =@tongTienNhap,
			ChiPhiKhac =@chiPhiKhac,
			LuongNV =@luongNV,
			NgayTongKet = @ngayTongKet
		Where  MaDoanhThu= @maDoanhThu
End